# https://www.bilibili.com/video/BV1W7411G7wP/?p=7&spm_id_from=pageDriver&vd_source=8bd7b24b38e3e12c558d839b352b32f4
# 刚发现up把测试数据上传了！
# https://gitee.com/plusyou13/py_tools
import pandas as pd
import copy

products = pd.read_excel('../resources/input_py_tools/007-008/007/List.xlsx')
print(products)

# 找最贵的产品
products.sort_values(by='Price', inplace=True, ascending=False)
print(products)

# 在“不值”的物品中，买得最贵的东西是啥
products.sort_values(by=['Worthy', 'Price'], inplace=True, ascending=[True, False])
print(products)

